﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DTO;
using System.Data;

namespace DAO
{
    public class CongTyVanChuyenDAO
    {
        //Load danh sach CTVC
        public DataTable LoadDSCTVC()
        {
            string sql = "select * from CongTyVanChuyen";
            return Dataprovider.ExcuteQuery(sql);
        }

        //Them cong ty van chuyen
        public int ThemCTVC(CongTyVanChuyenDTO ctDTO)
        {
            string sql = "insert into CongTyVanChuyen Values(N'" + ctDTO.TenCTVC + "',N'" + ctDTO.DiaChi + "','" + ctDTO.DienThoai + "','" + ctDTO.Email + "')";
            return Dataprovider.ExcuteNonQuery(sql);
        }
    }
}
